﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Manage/ManageMasterPage.master" AutoEventWireup="true" CodeFile="Send.aspx.cs" Inherits="Manage_Send" Theme="主题1"%>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div style="margin: 0px auto; width: 100%; text-align:center;background-color:#f3f9eb;padding-bottom:100px;padding-top:30px" >
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Ono" DataSourceID="SqlDataSource1" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" CssClass="mGrid">
            <Columns>
                <asp:CommandField SelectText="完成派送" ShowSelectButton="True" />
                <asp:BoundField DataField="Ono" HeaderText="订单号" ReadOnly="True" SortExpression="Ono" />
                <asp:BoundField DataField="Aaccount" HeaderText="下单账号" SortExpression="Aaccount" />
                <asp:BoundField DataField="Oname" HeaderText="收餐人姓名" SortExpression="Oname" />
                <asp:BoundField DataField="Ophone" HeaderText="收餐联系方式" SortExpression="Ophone" />
                <asp:BoundField DataField="Oadr" HeaderText="收餐地址" SortExpression="Oadr" />
                <asp:BoundField DataField="Opayway" HeaderText="支付方式" SortExpression="Opayway" />
                <asp:BoundField DataField="Osumprice" HeaderText="总价" SortExpression="Osumprice" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=SUBAI-WORKSTATI;Initial Catalog=Restaurant;Persist Security Info=True;User ID=Manager;Password=321" ProviderName="System.Data.SqlClient" SelectCommand="SELECT A1.Ono, A2.Aaccount, A1.Oname, A1.Ophone, A1.Oadr, A1.Opayway, A1.Osumprice FROM dbo.Manager_Order AS A1 INNER JOIN dbo.Manager_Set_Order AS A2 ON A1.Ono = A2.Ono WHERE (A1.Ostate = @Ostate) AND (A1.Opaystate = @Opaystate)">
            <SelectParameters>
                <asp:Parameter DefaultValue="正在派送" Name="Ostate" Type="String" />
                <asp:Parameter DefaultValue="False" Name="Opaystate" Type="Boolean" />
            </SelectParameters>
        </asp:SqlDataSource>
    </div>
</asp:Content>

